﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using KP_CommonLibrary.KP_DataAccess;
using System.Data;
using Microsoft.ApplicationBlocks.Data;
using KP_CommonLibrary.KP_ObjectReferences;
namespace KEEPER_BRR_13dotNET.DataAccess
{
   public class DAL_KPHoSoCn:KP_DALListBase
    {
       public DAL_KPHoSoCn()
           : base("tblHoSoCn")
       {
       }
       public DataTable FindHoSoCn(string soCmnd)
       {
           return SqlHelper.ExecuteDataTable(KP_OCnnSql.Cnn_String, "kp_FindHoSoCnByCmnd", soCmnd);
       }
       public DataTable FindHoSoCn(string tenGt_K, string soGt_K)
       {
           return SqlHelper.ExecuteDataTable(KP_OCnnSql.Cnn_String, "kp_FindHoSoCnByGtK", new object[] { tenGt_K, soGt_K });
       }
       public DataTable FindHoSoCnByMa_HsCn(string ma_HsCn)
       {
           return SqlHelper.ExecuteDataTable(KP_OCnnSql.Cnn_String, "kp_FindHoSoCnByMaHsCn", ma_HsCn);
       }
    }
}
